package com.caifu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.caifu.pojo.YlContractInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 
 * @since 2020-11-09
 */
public interface YlContractInfoMapper extends BaseMapper<YlContractInfo> {
    /**
    * 
    * 功能描述：查询最大的合同截止日期
    * 
    * @Param userNo 用户编号
    * @Return      
    * @Exception   
    * @Author  GZ
    * @Date   2020/11/12 18:01
    */
    @Select(" select * from yl_contract_info where USER_NO=#{userNo} and is_effective=1 ")
    YlContractInfo queryMaxContractEndDate(@Param("userNo") String userNo);
}
